package com.ubst.smartad.impl.admin.status;

import java.sql.*;
import java.util.*;
import java.io.*;

import com.ubst.smartad.common.TimeUtil;
import com.ubst.smartad.logger.Debug;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;

public class StatusMngImpl {
	
	Connection con = null;
	private String serverName;
	private Debug debug;
	//private FileHostEnv fhostEnv;


    /** 
     * 생성자
     *   
     *   
    */ 
	public StatusMngImpl(Connection con, String serverName, String log_level) {
		this.con = con;
		this.serverName = serverName;
		this.debug = new Debug("StatusMngImpl", log_level);
		//this.fhostEnv = FileHostEnv.getInstance(serverName);

	}

	/**
	 *  @author Kswany
	 * 	Status(현황판) - Manage-스케줄 작업 결과  jqGrid List 가져오기
	 * 
	 *  searchStr: 검색조건
	 *  orderBy: sort조건
	 *  prev_page: first limit 
	 *  next_page: last limit
	 *  
	 * **/
	public List getJqgridManage1List(String searchStr, String orderBy) 
//			throws SQLException{
			throws Exception{
		PreparedStatement pstmt=null;
		ResultSet rs = null;

		HashMap log_data_map = null;
		List log_datas = new ArrayList();
		
		try{			
			
			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분
			 */
			// 가상데이터
			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집1");log_data_map.put("result", "실패");
			log_datas.add(log_data_map);
			
			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집2");log_data_map.put("result", "실패");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집3");log_data_map.put("result", "실패");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집4");log_data_map.put("result", "실패");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집5");log_data_map.put("result", "실패");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집");log_data_map.put("result", "실패");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집");log_data_map.put("result", "실패");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집");log_data_map.put("result", "실패");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집");log_data_map.put("result", "실패");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집");log_data_map.put("result", "실패");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집");log_data_map.put("result", "실패");
			log_datas.add(log_data_map);
						
	//	}catch (SQLException e){
		}catch (Exception e){
			throw e;
		}finally{
	//		if ( rs != null) try{rs.close();}catch(SQLException ee){}
	//		if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
	
		return log_datas;
	}

	/**
	 *  @author Kswany
	 * 	Status(현황판) - Manage-계정 신청 내역  jqGrid List 가져오기
	 * 
	 *  searchStr: 검색조건
	 *  orderBy: sort조건
	 *  prev_page: first limit 
	 *  next_page: last limit
	 *  
	 * **/
	public List getJqgridManage2List(String searchStr, String orderBy) 
//			throws SQLException{
			throws Exception{
		PreparedStatement pstmt=null;
		ResultSet rs = null;

		HashMap log_data_map = null;
		List log_datas = new ArrayList();
		
		try{			
			
			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분
			 */
			// 가상데이터
			log_data_map = new HashMap();
			log_data_map.put("user", "Korea11");log_data_map.put("system_name", "centos");log_data_map.put("account", "joins7");log_data_map.put("req_date", "2013-01-13");
			log_datas.add(log_data_map);
			
			log_data_map = new HashMap();
			log_data_map.put("user", "Korea12");log_data_map.put("system_name", "centos");log_data_map.put("account", "joins7");log_data_map.put("req_date", "2013-01-13");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("user", "Korea13");log_data_map.put("system_name", "centos");log_data_map.put("account", "joins7");log_data_map.put("req_date", "2013-01-13");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("user", "Korea14");log_data_map.put("system_name", "centos");log_data_map.put("account", "joins7");log_data_map.put("req_date", "2013-01-13");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("user", "Korea15");log_data_map.put("system_name", "centos");log_data_map.put("account", "joins7");log_data_map.put("req_date", "2013-01-13");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("user", "Korea11");log_data_map.put("system_name", "centos");log_data_map.put("account", "joins7");log_data_map.put("req_date", "2013-01-13");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("user", "Korea11");log_data_map.put("system_name", "centos");log_data_map.put("account", "joins7");log_data_map.put("req_date", "2013-01-13");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("user", "Korea11");log_data_map.put("system_name", "centos");log_data_map.put("account", "joins7");log_data_map.put("req_date", "2013-01-13");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("user", "Korea11");log_data_map.put("system_name", "centos");log_data_map.put("account", "joins7");log_data_map.put("req_date", "2013-01-13");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("user", "Korea11");log_data_map.put("system_name", "centos");log_data_map.put("account", "joins7");log_data_map.put("req_date", "2013-01-13");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("user", "Korea11");log_data_map.put("system_name", "centos");log_data_map.put("account", "joins7");log_data_map.put("req_date", "2013-01-13");
			log_datas.add(log_data_map);
						
	//	}catch (SQLException e){
		}catch (Exception e){
			throw e;
		}finally{
	//		if ( rs != null) try{rs.close();}catch(SQLException ee){}
	//		if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
	
		return log_datas;
	}

	/**
	 *  @author Kswany
	 * 	Status(현황판) - Manage-로그온 세션  jqGrid List 가져오기
	 * 
	 *  searchStr: 검색조건
	 *  orderBy: sort조건
	 *  prev_page: first limit 
	 *  next_page: last limit
	 *  
	 * **/
	public List getJqgridManage3List(String searchStr, String orderBy) 
//			throws SQLException{
			throws Exception{
		PreparedStatement pstmt=null;
		ResultSet rs = null;

		HashMap log_data_map = null;
		List log_datas = new ArrayList();
		
		try{			
			
			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분
			 */
			// 가상데이터
			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집1");log_data_map.put("result", "실패");
			log_datas.add(log_data_map);
			
			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집2");log_data_map.put("result", "실패");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집3");log_data_map.put("result", "실패");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집4");log_data_map.put("result", "실패");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집5");log_data_map.put("result", "실패");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집");log_data_map.put("result", "실패");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집");log_data_map.put("result", "실패");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집");log_data_map.put("result", "실패");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집");log_data_map.put("result", "실패");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집");log_data_map.put("result", "실패");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집");log_data_map.put("result", "실패");
			log_datas.add(log_data_map);
			
	//	}catch (SQLException e){
		}catch (Exception e){
			throw e;
		}finally{
	//		if ( rs != null) try{rs.close();}catch(SQLException ee){}
	//		if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
	
		return log_datas;
	}

	/**
	 *  @author Kswany
	 * 	Status(현황판) - Manage-비밀번호 변경 추적  jqGrid List 가져오기   
	 * 
	 *  searchStr: 검색조건
	 *  orderBy: sort조건
	 *  prev_page: first limit 
	 *  next_page: last limit
	 *  
	 * **/
	public List getJqgridManage4List(String searchStr, String orderBy) 
//			throws SQLException{
			throws Exception{
		PreparedStatement pstmt=null;
		ResultSet rs = null;

		HashMap log_data_map = null;
		List log_datas = new ArrayList();
		
		try{			
			
			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분
			 */
			// 가상데이터
			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집1");log_data_map.put("result", "실패");
			log_datas.add(log_data_map);
			
			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집2");log_data_map.put("result", "실패");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집3");log_data_map.put("result", "실패");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집4");log_data_map.put("result", "실패");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집5");log_data_map.put("result", "실패");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집");log_data_map.put("result", "실패");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집");log_data_map.put("result", "실패");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집");log_data_map.put("result", "실패");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집");log_data_map.put("result", "실패");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집");log_data_map.put("result", "실패");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집");log_data_map.put("result", "실패");
			log_datas.add(log_data_map);
			
	//	}catch (SQLException e){
		}catch (Exception e){
			throw e;
		}finally{
	//		if ( rs != null) try{rs.close();}catch(SQLException ee){}
	//		if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
	
		return log_datas;
	}

	/**
	 *  @author Kswany
	 * 	Status(현황판) - Manage-작업 로그  jqGrid List 가져오기
	 * 
	 *  searchStr: 검색조건
	 *  orderBy: sort조건
	 *  prev_page: first limit 
	 *  next_page: last limit
	 *  
	 * **/
	public List getJqgridManage5List(String searchStr, String orderBy) 
//			throws SQLException{
			throws Exception{
		PreparedStatement pstmt=null;
		ResultSet rs = null;

		HashMap log_data_map = null;
		List log_datas = new ArrayList();
		
		try{			
			
			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분
			 */
			// 가상데이터
			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집1");log_data_map.put("result", "실패");log_data_map.put("worker", "test01");
			log_datas.add(log_data_map);
			
			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집2");log_data_map.put("result", "실패");log_data_map.put("worker", "test01");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집3");log_data_map.put("result", "실패");log_data_map.put("worker", "test01");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집4");log_data_map.put("result", "실패");log_data_map.put("worker", "test01");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집5");log_data_map.put("result", "실패");log_data_map.put("worker", "test01");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집");log_data_map.put("result", "실패");log_data_map.put("worker", "test01");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집");log_data_map.put("result", "실패");log_data_map.put("worker", "test01");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집");log_data_map.put("result", "실패");log_data_map.put("worker", "test01");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집");log_data_map.put("result", "실패");log_data_map.put("worker", "test01");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집");log_data_map.put("result", "실패");log_data_map.put("worker", "test01");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("time", "2013-01-13 22:52");log_data_map.put("work", "윈도우즈 계정수집");log_data_map.put("result", "실패");log_data_map.put("worker", "test01");
			log_datas.add(log_data_map);
			
	//	}catch (SQLException e){
		}catch (Exception e){
			throw e;
		}finally{
	//		if ( rs != null) try{rs.close();}catch(SQLException ee){}
	//		if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
	
		return log_datas;
	}
	
	
	/**
	 *  @author Kswany
	 * 	Status(현황판) - Account-정상 계정  jqGrid List 가져오기
	 * 
	 *  searchStr: 검색조건
	 *  orderBy: sort조건
	 *  
	 * **/
	public List getJqgridAccount1List(String searchStr, String orderBy) 
//			throws SQLException{
			throws Exception{
		PreparedStatement pstmt=null;
		ResultSet rs = null;

		HashMap log_data_map = null;
		List log_datas = new ArrayList();
		
		try{			
			
			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분
			 */
			// 가상데이터
			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin1");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);
			
			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin2");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin3");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin4");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin5");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin1");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin1");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin1");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin1");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin1");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin1");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);
			
			
	//	}catch (SQLException e){
		}catch (Exception e){
			throw e;
		}finally{
	//		if ( rs != null) try{rs.close();}catch(SQLException ee){}
	//		if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
	
		return log_datas;
	}
	
	
	/**
	 *  @author Kswany
	 * 	Status(현황판) - Account-유효 계정  jqGrid List 가져오기
	 * 
	 *  searchStr: 검색조건
	 *  orderBy: sort조건
	 *  
	 * **/
	public List getJqgridAccount2List(String searchStr, String orderBy) 
//			throws SQLException{
			throws Exception{
		PreparedStatement pstmt=null;
		ResultSet rs = null;

		HashMap log_data_map = null;
		List log_datas = new ArrayList();
		
		try{			
			
			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분
			 */
			// 가상데이터
			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin1");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);
			
			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin2");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin3");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin4");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin5");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin1");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin1");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin1");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin1");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin1");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin1");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);
			
			
	//	}catch (SQLException e){
		}catch (Exception e){
			throw e;
		}finally{
	//		if ( rs != null) try{rs.close();}catch(SQLException ee){}
	//		if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
	
		return log_datas;
	}
	
	
	/**
	 *  @author Kswany
	 * 	Status(현황판) - Account-만료 계정  jqGrid List 가져오기
	 * 
	 *  searchStr: 검색조건
	 *  orderBy: sort조건
	 *  
	 * **/
	public List getJqgridAccount3List(String searchStr, String orderBy) 
//			throws SQLException{
			throws Exception{
		PreparedStatement pstmt=null;
		ResultSet rs = null;

		HashMap log_data_map = null;
		List log_datas = new ArrayList();
		
		try{			
			
			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분
			 */
			// 가상데이터
			log_data_map = new HashMap();
			log_data_map.put("user", "UNIX");log_data_map.put("system_name", "redhat");log_data_map.put("account", "admin01");log_data_map.put("expire_date", "2013-07-18");
			log_datas.add(log_data_map);
			
			log_data_map = new HashMap();
			log_data_map.put("user", "UNIX");log_data_map.put("system_name", "redhat");log_data_map.put("account", "admin02");log_data_map.put("expire_date", "2013-07-18");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("user", "UNIX");log_data_map.put("system_name", "redhat");log_data_map.put("account", "admin03");log_data_map.put("expire_date", "2013-07-18");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("user", "UNIX");log_data_map.put("system_name", "redhat");log_data_map.put("account", "admin04");log_data_map.put("expire_date", "2013-07-18");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("user", "UNIX");log_data_map.put("system_name", "redhat");log_data_map.put("account", "admin05");log_data_map.put("expire_date", "2013-07-18");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("user", "UNIX");log_data_map.put("system_name", "redhat");log_data_map.put("account", "admin01");log_data_map.put("expire_date", "2013-07-18");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("user", "UNIX");log_data_map.put("system_name", "redhat");log_data_map.put("account", "admin01");log_data_map.put("expire_date", "2013-07-18");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("user", "UNIX");log_data_map.put("system_name", "redhat");log_data_map.put("account", "admin01");log_data_map.put("expire_date", "2013-07-18");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("user", "UNIX");log_data_map.put("system_name", "redhat");log_data_map.put("account", "admin01");log_data_map.put("expire_date", "2013-07-18");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("user", "UNIX");log_data_map.put("system_name", "redhat");log_data_map.put("account", "admin01");log_data_map.put("expire_date", "2013-07-18");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("user", "UNIX");log_data_map.put("system_name", "redhat");log_data_map.put("account", "admin01");log_data_map.put("expire_date", "2013-07-18");
			log_datas.add(log_data_map);

	//	}catch (SQLException e){
		}catch (Exception e){
			throw e;
		}finally{
	//		if ( rs != null) try{rs.close();}catch(SQLException ee){}
	//		if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
	
		return log_datas;
	}

	/**
	 *  @author Kswany
	 * 	Status(현황판) - Account-비정상 계정  jqGrid List 가져오기
	 * 
	 *  searchStr: 검색조건
	 *  orderBy: sort조건
	 *  
	 * **/
	public List getJqgridAccount4List(String searchStr, String orderBy) 
//			throws SQLException{
			throws Exception{
		PreparedStatement pstmt=null;
		ResultSet rs = null;

		HashMap log_data_map = null;
		List log_datas = new ArrayList();
		
		try{			
			
			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분
			 */
			// 가상데이터
			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin1");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);
			
			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin2");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin3");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin4");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin5");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin1");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin1");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin1");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin1");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin1");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin1");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);
			
			
	//	}catch (SQLException e){
		}catch (Exception e){
			throw e;
		}finally{
	//		if ( rs != null) try{rs.close();}catch(SQLException ee){}
	//		if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
	
		return log_datas;
	}
	
	/**
	 *  @author Kswany
	 * 	Status(현황판) - Account-잠긴 계정  jqGrid List 가져오기     
	 * 
	 *  searchStr: 검색조건
	 *  orderBy: sort조건
	 *  
	 * **/
	public List getJqgridAccount5List(String searchStr, String orderBy) 
//			throws SQLException{
			throws Exception{
		PreparedStatement pstmt=null;
		ResultSet rs = null;

		HashMap log_data_map = null;
		List log_datas = new ArrayList();
		
		try{			
			
			/*
			 *  DB value 값세팅 구현 로직 들어갈 부분
			 */
			// 가상데이터
			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin1");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);
			
			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin2");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin3");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin4");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin5");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin1");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin1");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin1");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin1");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin1");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);

			log_data_map = new HashMap();
			log_data_map.put("type", "UNIX");log_data_map.put("system", "redhat");log_data_map.put("account", "admin1");log_data_map.put("last_login_time", "2013-01-13 22:52");
			log_datas.add(log_data_map);
			
			
	//	}catch (SQLException e){
		}catch (Exception e){
			throw e;
		}finally{
	//		if ( rs != null) try{rs.close();}catch(SQLException ee){}
	//		if ( pstmt != null) try{pstmt.close();}catch(SQLException ee){}
		}
	
		return log_datas;
	}
	
	
}
